Manual publication DB insertion from raw text using syntax features

Publications and conferences of Dr. CHIRA Camelia, Profesor Universitar

http://www.cs.ubbcluj.ro/~cchira


In [1]:
class HelperMethods:
    @staticmethod
    def IsDate(text):
#         print("text")
#         print(text)
        for c in text.lstrip():
            if c not in "1234567890 ":
                return False
        return True

In [2]:
import pandas
import requests

In [3]:
page = requests.get('http://www.cs.ubbcluj.ro/~cchira/publications.html')

In [4]:
data = page.text

In [5]:
from bs4 import BeautifulSoup

In [6]:
soup = BeautifulSoup(data)

In [134]:
def SearchDate(text):
    date_val = re.search('\(?(1|2)(9|0)[0-9]{2}( ?)(\.|,|\))', text)
    try:
        date = date_val.group(0)
    except AttributeError:
        print(text)
    return date.lstrip('\(').rstrip(",. \)")

In [104]:
import re
def GetPublicationTitle(text):
    match = re.search(', ([a-zA-Z ]+-?:?){3,}(,|.)', text)
    try:
        title = match.group(0).lstrip(', ')
    except AttributeError:
        return ""
    date = SearchDate(text)
    return title, date

In [105]:
def GetPublicationTitle_B(text):
#     print("B: ")
#     print(text)
    authors = "".join(text.split('.,'))
    title_val = re.search('([a-zA-Z]+ ?-?)+(,)', text)
    title = title_val.group(0)
    date = SearchDate(text)
    return title, date

In [135]:
pubs = []
# print(soup.find_all('div'))
for e in soup.find_all('div', attrs={"class": "section_mine"}):

    lines = e.find_all("p")
    for line in lines:
#         print(line)
        try:
            title = line.find_all('a')
            title = title[0].contents[0]
            date = SearchDate(line.text)
        except:
            title, date = GetPublicationTitle(line.text)
        if len(title) < 25 and '.' in title:
            title, date = GetPublicationTitle_B(line.text)
        print("title: ", title)
        print("date: ", date)
        pubs.append((title, date))


title:  Improving Fall Detection Using an On-Wrist Wearable Accelerometer
date:  2018
title:  Key features for the characterization of Android malware families
date:  2017
title:  The generalized traveling salesman problem solved with ant algorithms
date:  2017
title:  MobiContext: A Context-Aware Cloud-Based Venue Recommendation Framework
date:  2017
title:  A parallel evolutionary approach to community detection in complex networks
date:  2017
title:  Characterization of Android Malware Families by a Reduced Set of Static Features,
date:  2017
title:  Gene clustering for time-series microarray with production outputs
date:  2016
title:  Evolutionary community detection in complex and dynamic networks 
date:  2016
title:  A hybrid intelligent recognition system for the early detection of strokes
date:  2015
title:  S4MPLE—Sampler for Multiple Protein-Ligand Entities: Methodology and Rigid-Site Docking Benchmarking
date:  2015
title:  Improving Human Activity Recognition and its Application in Early Stroke Diagnosis
date:  2015
title:  Evolution and dynamics of node-weighted networks for cellular automata computation
date:  2015
title:  Best-order crossover for permutation-based evolutionary algorithms
date:  2015
title:  An improved immigration memetic algorithm for solving the heterogeneous fixed fleet vehicle routing problem
date:  2015
title:  A Hybrid Evolutionary and Multiagent Reinforcement Learning Approach to Accelerate the Computation of Traffic Assignment
date:  2015
title:  Multi-objective Evolutionary Traffic Assignment
date:  2015
title:  A multi-objective evolutionary approach to imbalanced classification problems
date:  2015
title:  Route assignment using multi-objective evolutionary search
date:  2015
title:  On the Selection of Key Features for Android Malware Characterization
date:  2015
title:  Shape-Output Gene Clustering for Time Series Microarrays
date:  2015
title:  A Cluster Merging Method for Time Series microarray with production Values
date:  2014
title:  Urban bicycles renting systems: Modelling and optimization using nature-inspired search methods
date:  2014
title:  Predictability in Cellular Automata
date:  2014
title:  Game theory and extremal optimization for community detection in complex dynamic networks
date:  2014
title:  A hybrid approach based on genetic algorithms for solving the Clustered Vehicle Routing Problem,
date:  2014
title:  Network Topologies for Cellular Automata Computation
date:  2014
title:  Cell state change dynamics in cellular automata
date:  2013
title:  An intelligent route management system for electric vehicle charging
date:  2013
title:  Diverse Accurate Feature Selection for Microarray Cancer Diagnosis
date:  2013
title:  A Preliminary Study on Early Diagnosis of Illnesses Based on Activity Disturbances,
date:  2013
title:  Classifiers with a reject option for early time-series classification,
date:  2013
title:  Using a Hybrid Cellular Automata Topology and Neighborhood in Rule Discovery,
date:  2013
title:  Human Activity Recognition and Feature Selection for Stroke Early Diagnosis,
date:  2013
title:  Gene Clustering in Time Series Microarray Analysis,
date:  2013
title:  Recombination Operators in Permutation-Based Evolutionary Algorithms for the Travelling Salesman Problem.
date:  2012
title:  Mass Media Strategies: Hybrid Approach using a Bioinspired Algorithm and Social Data Mining.
date:  2012
title:  Nature Inspired Cooperative Strategies for Optimization
date:  2012
title:  Logistics Management and Optimization through Hybrid Artificial Intelligence Systems
date:  2012
title:  Hybrid ant models with a transition policy for solving a complex problem
date:  2012
title:  Intelligent system for measuring stress: StressTIC,
date:  2012
title:  Guest editorial: special issue on nature inspired cooperative strategies for optimization
date:  2012
title:  New Majority Rule and Network Topology for Cellular Automata
date:  2012
title:  A Collaborative Evolutionary Approach to Resource-Constrained Project Scheduling
date:  2012
title:  Evolutionary Detection of Community Structures in Complex Networks: a New Fitness Function,
date:  2012
title:  Modeling and replicating higher-order dependencies in genetic algorithms,
date:  2012
title:  Hybrid Evolutionary Algorithm with a Composite Fitness Function for Protein Structure Prediction,
date:  2012
title:  The Role of Crossover in Evolutionary Approaches to Resource-Constrained Project Scheduling,
date:  2012
title:  Dynamics of Networks Evolved for Cellular Automata Computation,
date:  2012
title:  Ensemble of Binary Learners for Reliable Text Categorization with a Reject Option,
date:  2012
title:  Error-Correcting Output Codes for Multi-Label Text Categorization
date:  2012
title:  A Game Theoretic Approach to the Community Detection in Social Networks Problem,
date:  2011
title:  Hill-Climbing Search and Diversification within an Evolutionary Approach to Protein Structure Prediction
date:  2011
title:  Collaborative search operators for evolutionary approaches to density classification in cellular automata
date:  2011
title:  Evolutionary Community Structure Detection
date:  2011
title:  Evolutionary Algorithms for Protein Structure Prediction in Lattice Models
date:  2011
title:  Evolutionary Computing in the Study of Complex Systems
date:  2011
title:  Heuristic Algorithms for Solving the Generalized Vehicle Routing Problem,
date:  2011
title:  Sensitive Ants in Solving the Generalized Vehicle Routing Problem,
date:  2011
title:  A New Gene Selection Method Based on Random Subspace Ensemble for Microarray Cancer Classification,
date:  2011
title:  Enhancing the Computational Mechanics of Cellular Automata,
date:  2011
title:  Collaborative evolutionary search for density classification in cellular automata,
date:  2011
title:  Towards the Efficient Evolution of Particle-Based Computation in Cellular Automata,
date:  2011
title:  A Hybrid Evolutionary Approach to Protein Structure Prediction with Lattice Models,
date:  2011
title:  Fitness Evaluation for Overlapping Community Detection in Complex Networks,
date:  2011
title:  Collaborative Community Detection in Complex Networks,
date:  2011
title:  Comparative Analysis of Recombination Operators in Genetic Algorithms for the Travelling Salesman Problem,
date:  2011
title:  P systems with control nuclei: The concept
date:  2010
title:  Hill-Climbing Search in Evolutionary Models for Protein Folding Simulations
date:  2010
title:  Learning Sensitive Stigmergic Agents for Solving Complex Problems
date:  2010
title:  Evolutionary Algorithms for Protein Structure Prediction in Simplified Lattice Models,
date:  2010
title:  Collaborative Evolutionary Algorithms for detecting Overlapping Communities in Complex Networks,
date:  2010
title:  Simplified Chain Folding Models as Metaheuristic Benchmark for Tuning Real Protein Folding Algorithms?
date:  2010
title:  A Hybrid ACO Approach to the Matrix Bandwidth Minimization Problem.
date:  2010
title:  A Genetic Algorithm for Solving the Generalized Vehicle Routing Problem.
date:  2010
title:  An Evolutionary Model based on Hill-Climbing Search Operators for Protein Structure Prediction,
date:  2010
title:  Hill-climbing Search and Fingerprint Diversification in an Evolutionary Model for Protein Structure Prediction,
date:  2010
title:  A Step-Back Sensitive Ant Model for Solving Complex Problems
date:  2009
title:  Distributed Asynchronous Collaborative Search
date:  2009
title:  Asynchronous Collaborative Search using Adaptive Coevolving Subpopulations ,
date:  2009
title:  Solving the Linear Ordering Problem using Ant Models,
date:  2009
title:  Asynchronous Evolutionary Search: Multi-Population Collaboration and Complex Dynamics,
date:  2009
title:  Cellular Automata Rule Detection using Circular Asynchronous Evolutionary Search,
date:  2009
title:  A Hybrid Ant-Based Approach to the Economic Triangulation Problem for Input-Output Tables,
date:  2009
title:  Sensitive Ants: Inducing Diversity in the Colony,
date:  2009
title:  An Agent-Based Approach to Combinatorial Optimization,
date:  2008
title:  Complex Dynamics in an Evolutionary Asynchronous Search Model,
date:  2008
title:  A Multi-Agent Stigmergic Model for Complex Optimization Problems,
date:  2008
title:  New Parallel Programming Language Design: A Bridge between Brain Models and Multi-Core/
date:  2008
title:  Distribution,
date:  2008
title:  Stigmergy and Sensitivity in Heterogeneous Agent-Based Models,
date:  2008
title:  Analysis of a Distributed Collaborative Evolutionary Algorithm,
date:  2008
title:  A Hybrid Ant-Based System for Gate Assignment Problem.
date:  2008
title:  Hybrid Multi-Population Collaborative Asynchronous Search.
date:  2008
title:  Heterogeneous Sensitive Ant Model for Combinatorial Optimization,
date:  2008
title:  Exploring Population Geometry and Multi-Agent Systems: A New Approach to Developing Evolutionary Techniques,
date:  1959
title:  An Agent-Based Collaborative Evolutionary Model for Multimodal Optimization,
date:  1975
title:  Sensitive Ant Model for Combinatorial Optimization,
date:  2008
title:  A Sensitive Metaheuristic for Solving a Large Optimization Problem,
date:  2008
title:  Cooperative Learning Sensitive Agent System for Combinatorial Optimization,
date:  2007
title:  Multi-Agent Systems for Distributed Collaborative Design,
date:  2007
title:  Principiile Agentilor Inteligenti,
date:  2007
title:  Sensitive Stigmergic Agent Systems - A Hybrid Approach to Combinatorial Optimization,
date:  2007
title:  Agent-Based Management and Optimization System for Distributed Computing,
date:  2007
title:  Multi-Agent Cooperative Design Support in Distributed Environments.
date:  2007
title:  Multi-Agent Distributed Computing,
date:  2007
title:  Sensitive ant systems in combinatorial optimization,
date:  2007
title:  Sensitive ant systems in combinatorial optimization,
date:  2007
title:  Simulating Microcapillary Networks Using Random Graphs,
date:  2007
title:  A Sensitive Robot Metaheuristic for Complex Applications,
date:  2007
title:  Sensitive Stigmergic Agent Systems,
date:  2007
title:  M,
date:  2007
title:  An agent-based approach to knowledge management in distributed design
date:  2006
title:  A multi-agent system for design information management anal support,
date:  2006
title:  Stigmergic Agent Optimization,
date:  2006
title:  A Multi-Agent Knowledge Management Architecture,
date:  2006
title:  M,
date:  2006
title:  Stigmergic Agents for Solving NP-difficult Problems,
date:  2006
title:  Reinforcing Ant Colony System for the Generalized Traveling Salesman Problem,
date:  2006
title:  A Multi-Agent Approach to Distributed Collaboration,
date:  2006
title:  Development of a Multi-Agent Information Management System,
date:  2006
title:  Chira,
date:  2005
title:  An Ontological and Agent Based approach to Knowledge Management within a Distributed Design Environment,
date:  2004
title:  Semantic Tools for Knowledge Management in Distributed Engineering Design,
date:  2004
title:  Ontology oriented knowledge management tool to support DFX activities,
date:  2004
title:  A Multi-Agent Architecture for Distributed Design,
date:  2003
title:  Development of Engineering Design Methodologies and Software Tools to Support the Creative Process of Design in a Distributed Environment,
date:  2003
title:  The Use of Ontologies for Defining Collaborative Design Processes,
date:  2003
title:  An agent-based approach to knowledge management in distributed design,
date:  2003
title:  Diez,
date:  2002
title:  Testing and Validation of a Distributed Design Tool using Protocol Analysis,
date:  2002
title:  The DFE Workbench a Case Study,
date:  2001
title:  The DFE Workbench Software Tool Case Study ecodesign,
date:  2001

DB Storage (TODO)

Time to store the entries in the papers DB table.


In [119]:
import mariadb
import json

In [120]:
with open('../credentials.json', 'r') as crd_json_fd:
    json_text = crd_json_fd.read()
    json_obj = json.loads(json_text)

In [121]:
credentials = json_obj["Credentials"]
username = credentials["username"]
password = credentials["password"]

In [122]:
table_name = "publications_cache"
db_name = "ubbcluj"

In [123]:
mariadb_connection = mariadb.connect(user=username, password=password, database=db_name)
mariadb_cursor = mariadb_connection.cursor()

In [137]:
for paper in pubs:
    
    title = ""
    pub_date = ""
    affiliations = ""
    
    try:
        pub_date = paper[1].lstrip()
        pub_date = str(pub_date) + "-01-01"
        if len(pub_date) != 10:
            pub_date = ""
    except:
        pass
    
    try:
        title = paper[0].lstrip()
    except:
        pass
    
    
    insert_string = "INSERT INTO {0} SET ".format(table_name)
    insert_string += "Title=\'{0}\', ".format(title)
    insert_string += "ProfessorId=\'{0}\', ".format(9)
    if pub_date != "":
        insert_string += "PublicationDate=\'{0}\', ".format(str(pub_date))
    insert_string += "Authors=\'{0}\', ".format("")
    insert_string += "Affiliations=\'{0}\' ".format("")
    print(insert_string)

    try:
        mariadb_cursor.execute(insert_string)
    except mariadb.ProgrammingError as pe:
        print("Error")
        raise pe
    except mariadb.IntegrityError:
        continue


INSERT INTO publications_cache SET Title='Improving Fall Detection Using an On-Wrist Wearable Accelerometer', ProfessorId='9', PublicationDate='2018-01-01', Authors='', Affiliations='' 
INSERT INTO publications_cache SET Title='Key features for the characterization of Android malware families', ProfessorId='9', PublicationDate='2017-01-01', Authors='', Affiliations='' 
INSERT INTO publications_cache SET Title='The generalized traveling salesman problem solved with ant algorithms', ProfessorId='9', PublicationDate='2017-01-01', Authors='', Affiliations='' 
INSERT INTO publications_cache SET Title='MobiContext: A Context-Aware Cloud-Based Venue Recommendation Framework', ProfessorId='9', PublicationDate='2017-01-01', Authors='', Affiliations='' 
INSERT INTO publications_cache SET Title='A parallel evolutionary approach to community detection in complex networks', ProfessorId='9', PublicationDate='2017-01-01', Authors='', Affiliations='' 
INSERT INTO publications_cache SET Title='Characterization of Android Malware Families by a Reduced Set of Static Features,', ProfessorId='9', PublicationDate='2017-01-01', Authors='', Affiliations='' 
INSERT INTO publications_cache SET Title='Gene clustering for time-series microarray with production outputs', ProfessorId='9', PublicationDate='2016-01-01', Authors='', Affiliations='' 
INSERT INTO publications_cache SET Title='Evolutionary community detection in complex and dynamic networks ', ProfessorId='9', PublicationDate='2016-01-01', Authors='', Affiliations='' 
INSERT INTO publications_cache SET Title='A hybrid intelligent recognition system for the early detection of strokes', ProfessorId='9', PublicationDate='2015-01-01', Authors='', Affiliations='' 
INSERT INTO publications_cache SET Title='S4MPLE—Sampler for Multiple Protein-Ligand Entities: Methodology and Rigid-Site Docking Benchmarking', ProfessorId='9', PublicationDate='2015-01-01', Authors='', Affiliations='' 
INSERT INTO publications_cache SET Title='Improving Human Activity Recognition and its Application in Early Stroke Diagnosis', ProfessorId='9', PublicationDate='2015-01-01', Authors='', Affiliations='' 
INSERT INTO publications_cache SET Title='Evolution and dynamics of node-weighted networks for cellular automata computation', ProfessorId='9', PublicationDate='2015-01-01', Authors='', Affiliations='' 
INSERT INTO publications_cache SET Title='Best-order crossover for permutation-based evolutionary algorithms', ProfessorId='9', PublicationDate='2015-01-01', Authors='', Affiliations='' 
INSERT INTO publications_cache SET Title='An improved immigration memetic algorithm for solving the heterogeneous fixed fleet vehicle routing problem', ProfessorId='9', PublicationDate='2015-01-01', Authors='', Affiliations='' 
INSERT INTO publications_cache SET Title='A Hybrid Evolutionary and Multiagent Reinforcement Learning Approach to Accelerate the Computation of Traffic Assignment', ProfessorId='9', PublicationDate='2015-01-01', Authors='', Affiliations='' 
INSERT INTO publications_cache SET Title='Multi-objective Evolutionary Traffic Assignment', ProfessorId='9', PublicationDate='2015-01-01', Authors='', Affiliations='' 
INSERT INTO publications_cache SET Title='A multi-objective evolutionary approach to imbalanced classification problems', ProfessorId='9', PublicationDate='2015-01-01', Authors='', Affiliations='' 
INSERT INTO publications_cache SET Title='Route assignment using multi-objective evolutionary search', ProfessorId='9', PublicationDate='2015-01-01', Authors='', Affiliations='' 
INSERT INTO publications_cache SET Title='On the Selection of Key Features for Android Malware Characterization', ProfessorId='9', PublicationDate='2015-01-01', Authors='', Affiliations='' 
INSERT INTO publications_cache SET Title='Shape-Output Gene Clustering for Time Series Microarrays', ProfessorId='9', PublicationDate='2015-01-01', Authors='', Affiliations='' 
INSERT INTO publications_cache SET Title='A Cluster Merging Method for Time Series microarray with production Values', ProfessorId='9', PublicationDate='2014-01-01', Authors='', Affiliations='' 
INSERT INTO publications_cache SET Title='Urban bicycles renting systems: Modelling and optimization using nature-inspired search methods', ProfessorId='9', PublicationDate='2014-01-01', Authors='', Affiliations='' 
INSERT INTO publications_cache SET Title='Predictability in Cellular Automata', ProfessorId='9', PublicationDate='2014-01-01', Authors='', Affiliations='' 
INSERT INTO publications_cache SET Title='Game theory and extremal optimization for community detection in complex dynamic networks', ProfessorId='9', PublicationDate='2014-01-01', Authors='', Affiliations='' 
INSERT INTO publications_cache SET Title='A hybrid approach based on genetic algorithms for solving the Clustered Vehicle Routing Problem,', ProfessorId='9', PublicationDate='2014-01-01', Authors='', Affiliations='' 
INSERT INTO publications_cache SET Title='Network Topologies for Cellular Automata Computation', ProfessorId='9', PublicationDate='2014-01-01', Authors='', Affiliations='' 
INSERT INTO publications_cache SET Title='Cell state change dynamics in cellular automata', ProfessorId='9', PublicationDate='2013-01-01', Authors='', Affiliations='' 
INSERT INTO publications_cache SET Title='An intelligent route management system for electric vehicle charging', ProfessorId='9', PublicationDate='2013-01-01', Authors='', Affiliations='' 
INSERT INTO publications_cache SET Title='Diverse Accurate Feature Selection for Microarray Cancer Diagnosis', ProfessorId='9', PublicationDate='2013-01-01', Authors='', Affiliations='' 
INSERT INTO publications_cache SET Title='A Preliminary Study on Early Diagnosis of Illnesses Based on Activity Disturbances,', ProfessorId='9', PublicationDate='2013-01-01', Authors='', Affiliations='' 
INSERT INTO publications_cache SET Title='Classifiers with a reject option for early time-series classification,', ProfessorId='9', PublicationDate='2013-01-01', Authors='', Affiliations='' 
INSERT INTO publications_cache SET Title='Using a Hybrid Cellular Automata Topology and Neighborhood in Rule Discovery,', ProfessorId='9', PublicationDate='2013-01-01', Authors='', Affiliations='' 
INSERT INTO publications_cache SET Title='Human Activity Recognition and Feature Selection for Stroke Early Diagnosis,', ProfessorId='9', PublicationDate='2013-01-01', Authors='', Affiliations='' 
INSERT INTO publications_cache SET Title='Gene Clustering in Time Series Microarray Analysis,', ProfessorId='9', PublicationDate='2013-01-01', Authors='', Affiliations='' 
INSERT INTO publications_cache SET Title='Recombination Operators in Permutation-Based Evolutionary Algorithms for the Travelling Salesman Problem.', ProfessorId='9', PublicationDate='2012-01-01', Authors='', Affiliations='' 
INSERT INTO publications_cache SET Title='Mass Media Strategies: Hybrid Approach using a Bioinspired Algorithm and Social Data Mining.', ProfessorId='9', PublicationDate='2012-01-01', Authors='', Affiliations='' 
INSERT INTO publications_cache SET Title='Nature Inspired Cooperative Strategies for Optimization', ProfessorId='9', PublicationDate='2012-01-01', Authors='', Affiliations='' 
INSERT INTO publications_cache SET Title='Logistics Management and Optimization through Hybrid Artificial Intelligence Systems', ProfessorId='9', PublicationDate='2012-01-01', Authors='', Affiliations='' 
INSERT INTO publications_cache SET Title='Hybrid ant models with a transition policy for solving a complex problem', ProfessorId='9', PublicationDate='2012-01-01', Authors='', Affiliations='' 
INSERT INTO publications_cache SET Title='Intelligent system for measuring stress: StressTIC,', ProfessorId='9', PublicationDate='2012-01-01', Authors='', Affiliations='' 
INSERT INTO publications_cache SET Title='Guest editorial: special issue on nature inspired cooperative strategies for optimization', ProfessorId='9', PublicationDate='2012-01-01', Authors='', Affiliations='' 
INSERT INTO publications_cache SET Title='New Majority Rule and Network Topology for Cellular Automata', ProfessorId='9', PublicationDate='2012-01-01', Authors='', Affiliations='' 
INSERT INTO publications_cache SET Title='A Collaborative Evolutionary Approach to Resource-Constrained Project Scheduling', ProfessorId='9', PublicationDate='2012-01-01', Authors='', Affiliations='' 
INSERT INTO publications_cache SET Title='Evolutionary Detection of Community Structures in Complex Networks: a New Fitness Function,', ProfessorId='9', PublicationDate='2012-01-01', Authors='', Affiliations='' 
INSERT INTO publications_cache SET Title='Modeling and replicating higher-order dependencies in genetic algorithms,', ProfessorId='9', PublicationDate='2012-01-01', Authors='', Affiliations='' 
INSERT INTO publications_cache SET Title='Hybrid Evolutionary Algorithm with a Composite Fitness Function for Protein Structure Prediction,', ProfessorId='9', PublicationDate='2012-01-01', Authors='', Affiliations='' 
INSERT INTO publications_cache SET Title='The Role of Crossover in Evolutionary Approaches to Resource-Constrained Project Scheduling,', ProfessorId='9', PublicationDate='2012-01-01', Authors='', Affiliations='' 
INSERT INTO publications_cache SET Title='Dynamics of Networks Evolved for Cellular Automata Computation,', ProfessorId='9', PublicationDate='2012-01-01', Authors='', Affiliations='' 
INSERT INTO publications_cache SET Title='Ensemble of Binary Learners for Reliable Text Categorization with a Reject Option,', ProfessorId='9', PublicationDate='2012-01-01', Authors='', Affiliations='' 
INSERT INTO publications_cache SET Title='Error-Correcting Output Codes for Multi-Label Text Categorization', ProfessorId='9', PublicationDate='2012-01-01', Authors='', Affiliations='' 
INSERT INTO publications_cache SET Title='A Game Theoretic Approach to the Community Detection in Social Networks Problem,', ProfessorId='9', PublicationDate='2011-01-01', Authors='', Affiliations='' 
INSERT INTO publications_cache SET Title='Hill-Climbing Search and Diversification within an Evolutionary Approach to Protein Structure Prediction', ProfessorId='9', PublicationDate='2011-01-01', Authors='', Affiliations='' 
INSERT INTO publications_cache SET Title='Collaborative search operators for evolutionary approaches to density classification in cellular automata', ProfessorId='9', PublicationDate='2011-01-01', Authors='', Affiliations='' 
INSERT INTO publications_cache SET Title='Evolutionary Community Structure Detection', ProfessorId='9', PublicationDate='2011-01-01', Authors='', Affiliations='' 
INSERT INTO publications_cache SET Title='Evolutionary Algorithms for Protein Structure Prediction in Lattice Models', ProfessorId='9', PublicationDate='2011-01-01', Authors='', Affiliations='' 
INSERT INTO publications_cache SET Title='Evolutionary Computing in the Study of Complex Systems', ProfessorId='9', PublicationDate='2011-01-01', Authors='', Affiliations='' 
INSERT INTO publications_cache SET Title='Heuristic Algorithms for Solving the Generalized Vehicle Routing Problem,', ProfessorId='9', PublicationDate='2011-01-01', Authors='', Affiliations='' 
INSERT INTO publications_cache SET Title='Sensitive Ants in Solving the Generalized Vehicle Routing Problem,', ProfessorId='9', PublicationDate='2011-01-01', Authors='', Affiliations='' 
INSERT INTO publications_cache SET Title='A New Gene Selection Method Based on Random Subspace Ensemble for Microarray Cancer Classification,', ProfessorId='9', PublicationDate='2011-01-01', Authors='', Affiliations='' 
INSERT INTO publications_cache SET Title='Enhancing the Computational Mechanics of Cellular Automata,', ProfessorId='9', PublicationDate='2011-01-01', Authors='', Affiliations='' 
INSERT INTO publications_cache SET Title='Collaborative evolutionary search for density classification in cellular automata,', ProfessorId='9', PublicationDate='2011-01-01', Authors='', Affiliations='' 
INSERT INTO publications_cache SET Title='Towards the Efficient Evolution of Particle-Based Computation in Cellular Automata,', ProfessorId='9', PublicationDate='2011-01-01', Authors='', Affiliations='' 
INSERT INTO publications_cache SET Title='A Hybrid Evolutionary Approach to Protein Structure Prediction with Lattice Models,', ProfessorId='9', PublicationDate='2011-01-01', Authors='', Affiliations='' 
INSERT INTO publications_cache SET Title='Fitness Evaluation for Overlapping Community Detection in Complex Networks,', ProfessorId='9', PublicationDate='2011-01-01', Authors='', Affiliations='' 
INSERT INTO publications_cache SET Title='Collaborative Community Detection in Complex Networks,', ProfessorId='9', PublicationDate='2011-01-01', Authors='', Affiliations='' 
INSERT INTO publications_cache SET Title='Comparative Analysis of Recombination Operators in Genetic Algorithms for the Travelling Salesman Problem,', ProfessorId='9', PublicationDate='2011-01-01', Authors='', Affiliations='' 
INSERT INTO publications_cache SET Title='P systems with control nuclei: The concept', ProfessorId='9', PublicationDate='2010-01-01', Authors='', Affiliations='' 
INSERT INTO publications_cache SET Title='Hill-Climbing Search in Evolutionary Models for Protein Folding Simulations', ProfessorId='9', PublicationDate='2010-01-01', Authors='', Affiliations='' 
INSERT INTO publications_cache SET Title='Learning Sensitive Stigmergic Agents for Solving Complex Problems', ProfessorId='9', PublicationDate='2010-01-01', Authors='', Affiliations='' 
INSERT INTO publications_cache SET Title='Evolutionary Algorithms for Protein Structure Prediction in Simplified Lattice Models,', ProfessorId='9', PublicationDate='2010-01-01', Authors='', Affiliations='' 
INSERT INTO publications_cache SET Title='Collaborative Evolutionary Algorithms for detecting Overlapping Communities in Complex Networks,', ProfessorId='9', PublicationDate='2010-01-01', Authors='', Affiliations='' 
INSERT INTO publications_cache SET Title='Simplified Chain Folding Models as Metaheuristic Benchmark for Tuning Real Protein Folding Algorithms?', ProfessorId='9', PublicationDate='2010-01-01', Authors='', Affiliations='' 
INSERT INTO publications_cache SET Title='A Hybrid ACO Approach to the Matrix Bandwidth Minimization Problem.', ProfessorId='9', PublicationDate='2010-01-01', Authors='', Affiliations='' 
INSERT INTO publications_cache SET Title='A Genetic Algorithm for Solving the Generalized Vehicle Routing Problem.', ProfessorId='9', PublicationDate='2010-01-01', Authors='', Affiliations='' 
INSERT INTO publications_cache SET Title='An Evolutionary Model based on Hill-Climbing Search Operators for Protein Structure Prediction,', ProfessorId='9', PublicationDate='2010-01-01', Authors='', Affiliations='' 
INSERT INTO publications_cache SET Title='Hill-climbing Search and Fingerprint Diversification in an Evolutionary Model for Protein Structure Prediction,', ProfessorId='9', PublicationDate='2010-01-01', Authors='', Affiliations='' 
INSERT INTO publications_cache SET Title='A Step-Back Sensitive Ant Model for Solving Complex Problems', ProfessorId='9', PublicationDate='2009-01-01', Authors='', Affiliations='' 
INSERT INTO publications_cache SET Title='Distributed Asynchronous Collaborative Search', ProfessorId='9', PublicationDate='2009-01-01', Authors='', Affiliations='' 
INSERT INTO publications_cache SET Title='Asynchronous Collaborative Search using Adaptive Coevolving Subpopulations ,', ProfessorId='9', PublicationDate='2009-01-01', Authors='', Affiliations='' 
INSERT INTO publications_cache SET Title='Solving the Linear Ordering Problem using Ant Models,', ProfessorId='9', PublicationDate='2009-01-01', Authors='', Affiliations='' 
INSERT INTO publications_cache SET Title='Asynchronous Evolutionary Search: Multi-Population Collaboration and Complex Dynamics,', ProfessorId='9', PublicationDate='2009-01-01', Authors='', Affiliations='' 
INSERT INTO publications_cache SET Title='Cellular Automata Rule Detection using Circular Asynchronous Evolutionary Search,', ProfessorId='9', PublicationDate='2009-01-01', Authors='', Affiliations='' 
INSERT INTO publications_cache SET Title='A Hybrid Ant-Based Approach to the Economic Triangulation Problem for Input-Output Tables,', ProfessorId='9', PublicationDate='2009-01-01', Authors='', Affiliations='' 
INSERT INTO publications_cache SET Title='Sensitive Ants: Inducing Diversity in the Colony,', ProfessorId='9', PublicationDate='2009-01-01', Authors='', Affiliations='' 
INSERT INTO publications_cache SET Title='An Agent-Based Approach to Combinatorial Optimization,', ProfessorId='9', PublicationDate='2008-01-01', Authors='', Affiliations='' 
INSERT INTO publications_cache SET Title='Complex Dynamics in an Evolutionary Asynchronous Search Model,', ProfessorId='9', PublicationDate='2008-01-01', Authors='', Affiliations='' 
INSERT INTO publications_cache SET Title='A Multi-Agent Stigmergic Model for Complex Optimization Problems,', ProfessorId='9', PublicationDate='2008-01-01', Authors='', Affiliations='' 
INSERT INTO publications_cache SET Title='New Parallel Programming Language Design: A Bridge between Brain Models and Multi-Core/', ProfessorId='9', PublicationDate='2008-01-01', Authors='', Affiliations='' 
INSERT INTO publications_cache SET Title='Distribution,', ProfessorId='9', PublicationDate='2008-01-01', Authors='', Affiliations='' 
INSERT INTO publications_cache SET Title='Stigmergy and Sensitivity in Heterogeneous Agent-Based Models,', ProfessorId='9', PublicationDate='2008-01-01', Authors='', Affiliations='' 
INSERT INTO publications_cache SET Title='Analysis of a Distributed Collaborative Evolutionary Algorithm,', ProfessorId='9', PublicationDate='2008-01-01', Authors='', Affiliations='' 
INSERT INTO publications_cache SET Title='A Hybrid Ant-Based System for Gate Assignment Problem.', ProfessorId='9', PublicationDate='2008-01-01', Authors='', Affiliations='' 
INSERT INTO publications_cache SET Title='Hybrid Multi-Population Collaborative Asynchronous Search.', ProfessorId='9', PublicationDate='2008-01-01', Authors='', Affiliations='' 
INSERT INTO publications_cache SET Title='Heterogeneous Sensitive Ant Model for Combinatorial Optimization,', ProfessorId='9', PublicationDate='2008-01-01', Authors='', Affiliations='' 
INSERT INTO publications_cache SET Title='Exploring Population Geometry and Multi-Agent Systems: A New Approach to Developing Evolutionary Techniques,', ProfessorId='9', PublicationDate='1959-01-01', Authors='', Affiliations='' 
INSERT INTO publications_cache SET Title='An Agent-Based Collaborative Evolutionary Model for Multimodal Optimization,', ProfessorId='9', PublicationDate='1975-01-01', Authors='', Affiliations='' 
INSERT INTO publications_cache SET Title='Sensitive Ant Model for Combinatorial Optimization,', ProfessorId='9', PublicationDate='2008-01-01', Authors='', Affiliations='' 
INSERT INTO publications_cache SET Title='A Sensitive Metaheuristic for Solving a Large Optimization Problem,', ProfessorId='9', PublicationDate='2008-01-01', Authors='', Affiliations='' 
INSERT INTO publications_cache SET Title='Cooperative Learning Sensitive Agent System for Combinatorial Optimization,', ProfessorId='9', PublicationDate='2007-01-01', Authors='', Affiliations='' 
INSERT INTO publications_cache SET Title='Multi-Agent Systems for Distributed Collaborative Design,', ProfessorId='9', PublicationDate='2007-01-01', Authors='', Affiliations='' 
INSERT INTO publications_cache SET Title='Principiile Agentilor Inteligenti,', ProfessorId='9', PublicationDate='2007-01-01', Authors='', Affiliations='' 
INSERT INTO publications_cache SET Title='Sensitive Stigmergic Agent Systems - A Hybrid Approach to Combinatorial Optimization,', ProfessorId='9', PublicationDate='2007-01-01', Authors='', Affiliations='' 
INSERT INTO publications_cache SET Title='Agent-Based Management and Optimization System for Distributed Computing,', ProfessorId='9', PublicationDate='2007-01-01', Authors='', Affiliations='' 
INSERT INTO publications_cache SET Title='Multi-Agent Cooperative Design Support in Distributed Environments.', ProfessorId='9', PublicationDate='2007-01-01', Authors='', Affiliations='' 
INSERT INTO publications_cache SET Title='Multi-Agent Distributed Computing,', ProfessorId='9', PublicationDate='2007-01-01', Authors='', Affiliations='' 
INSERT INTO publications_cache SET Title='Sensitive ant systems in combinatorial optimization,', ProfessorId='9', PublicationDate='2007-01-01', Authors='', Affiliations='' 
INSERT INTO publications_cache SET Title='Sensitive ant systems in combinatorial optimization,', ProfessorId='9', PublicationDate='2007-01-01', Authors='', Affiliations='' 
INSERT INTO publications_cache SET Title='Simulating Microcapillary Networks Using Random Graphs,', ProfessorId='9', PublicationDate='2007-01-01', Authors='', Affiliations='' 
INSERT INTO publications_cache SET Title='A Sensitive Robot Metaheuristic for Complex Applications,', ProfessorId='9', PublicationDate='2007-01-01', Authors='', Affiliations='' 
INSERT INTO publications_cache SET Title='Sensitive Stigmergic Agent Systems,', ProfessorId='9', PublicationDate='2007-01-01', Authors='', Affiliations='' 
INSERT INTO publications_cache SET Title='M,', ProfessorId='9', PublicationDate='2007-01-01', Authors='', Affiliations='' 
INSERT INTO publications_cache SET Title='An agent-based approach to knowledge management in distributed design', ProfessorId='9', PublicationDate='2006-01-01', Authors='', Affiliations='' 
INSERT INTO publications_cache SET Title='A multi-agent system for design information management anal support,', ProfessorId='9', PublicationDate='2006-01-01', Authors='', Affiliations='' 
INSERT INTO publications_cache SET Title='Stigmergic Agent Optimization,', ProfessorId='9', PublicationDate='2006-01-01', Authors='', Affiliations='' 
INSERT INTO publications_cache SET Title='A Multi-Agent Knowledge Management Architecture,', ProfessorId='9', PublicationDate='2006-01-01', Authors='', Affiliations='' 
INSERT INTO publications_cache SET Title='M,', ProfessorId='9', PublicationDate='2006-01-01', Authors='', Affiliations='' 
INSERT INTO publications_cache SET Title='Stigmergic Agents for Solving NP-difficult Problems,', ProfessorId='9', PublicationDate='2006-01-01', Authors='', Affiliations='' 
INSERT INTO publications_cache SET Title='Reinforcing Ant Colony System for the Generalized Traveling Salesman Problem,', ProfessorId='9', PublicationDate='2006-01-01', Authors='', Affiliations='' 
INSERT INTO publications_cache SET Title='A Multi-Agent Approach to Distributed Collaboration,', ProfessorId='9', PublicationDate='2006-01-01', Authors='', Affiliations='' 
INSERT INTO publications_cache SET Title='Development of a Multi-Agent Information Management System,', ProfessorId='9', PublicationDate='2006-01-01', Authors='', Affiliations='' 
INSERT INTO publications_cache SET Title='Chira,', ProfessorId='9', PublicationDate='2005-01-01', Authors='', Affiliations='' 
INSERT INTO publications_cache SET Title='An Ontological and Agent Based approach to Knowledge Management within a Distributed Design Environment,', ProfessorId='9', PublicationDate='2004-01-01', Authors='', Affiliations='' 
INSERT INTO publications_cache SET Title='Semantic Tools for Knowledge Management in Distributed Engineering Design,', ProfessorId='9', PublicationDate='2004-01-01', Authors='', Affiliations='' 
INSERT INTO publications_cache SET Title='Ontology oriented knowledge management tool to support DFX activities,', ProfessorId='9', PublicationDate='2004-01-01', Authors='', Affiliations='' 
INSERT INTO publications_cache SET Title='A Multi-Agent Architecture for Distributed Design,', ProfessorId='9', PublicationDate='2003-01-01', Authors='', Affiliations='' 
INSERT INTO publications_cache SET Title='Development of Engineering Design Methodologies and Software Tools to Support the Creative Process of Design in a Distributed Environment,', ProfessorId='9', PublicationDate='2003-01-01', Authors='', Affiliations='' 
INSERT INTO publications_cache SET Title='The Use of Ontologies for Defining Collaborative Design Processes,', ProfessorId='9', PublicationDate='2003-01-01', Authors='', Affiliations='' 
INSERT INTO publications_cache SET Title='An agent-based approach to knowledge management in distributed design,', ProfessorId='9', PublicationDate='2003-01-01', Authors='', Affiliations='' 
INSERT INTO publications_cache SET Title='Diez,', ProfessorId='9', PublicationDate='2002-01-01', Authors='', Affiliations='' 
INSERT INTO publications_cache SET Title='Testing and Validation of a Distributed Design Tool using Protocol Analysis,', ProfessorId='9', PublicationDate='2002-01-01', Authors='', Affiliations='' 
INSERT INTO publications_cache SET Title='The DFE Workbench a Case Study,', ProfessorId='9', PublicationDate='2001-01-01', Authors='', Affiliations='' 
INSERT INTO publications_cache SET Title='The DFE Workbench Software Tool Case Study ecodesign,', ProfessorId='9', PublicationDate='2001-01-01', Authors='', Affiliations='' 

In [68]:
mariadb_connection.close()

Conclusion

In the end, the DB only required ~4 manual modifications (deletions) with this code.

126 rows inserted.